USE [CTEM-DB-v1]
GO

/****** Object:  StoredProcedure [dbo].[Employee_GetSalaryReport]    Script Date: 02/10/2012 11:23:35 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		<Hainh>
-- Create date: <07/02/2012>
-- Description:	<Description,,>-- =============================================
CREATE PROCEDURE [dbo].[Employee_GetSalaryReport]
            @EmployeeID BIGINT
AS
BEGIN
    SELECT	S.*, E.Username, E.FullName
	FROM	EmployeeSalary S JOIN Employee E ON S.EmployeeID = E.EmployeeID
	Where   S.EmployeeID = @EmployeeID
END

GO

